select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')

Turquoise Ball Gown Strapless Floor-length Organza Beading 16 Birthday Dresses

Baby Pink V-neck Front Straps Back Short 16 Birthday Party Dress

Lavender Sweetheart Beaded Chiffon Sash Short Dress For 16 Birthday Party Dress

Pink Ball Gown Strapless Floor-length Organza Beading 16 Birthday Party Dresses

Light Blue Ruffled Short sweetheart 16 Birthday Party Dress

Black Ball Gown Sweetheart Floor-length Sequined and Tulle Appliques 16 Birthday Party Dresses

Red Ball Gown One Shoulder Floor-length Organza Ruffles and Beading 16 Birthday Party Dresses

Purple Ball Gown Strapless Floor-length Organza Ruffles 16 Party Dresses

Elegant Ball Gown Ruffles Red 16 Birthday Party Dresses

Beaded Ruffles Layered Decorate 16 Birthday Party Dress With Sweetheart Aqua Skirt

Appliques and Pick-ups Wine Red Exquisite Style For 2013 16 Birthday Party Dress

Leopard and Organza Beading Decorate Sweetheart Neckline Exquisite 16 Birthday Party Dress

All Colors Ball Gown Strapless Appliques and Ruffles Sweet Sixteen Quinceanera Dresses

Modest Ball Gown Sweet Sixteen Quinceanera Dresses with Strapless Ruffles and Embroidery for 2014

2014 Ball Gown Strapless Appliques and Sahes Sweet 16 Dresses for Party

Ball Gown Strapless Organza Embroidery Sweet Sixteen Quinceanera Dresses

All Colors Sweetheart Quinceanera Dresses with Beading and Ruffles for 2014

All Colors Strapless Sweet Sweet 16 Dresses with Appliques and Ruffles for 2014 New

All Colors Ruffles Sweetheart Beading and Ruffles Dresses For a Quince in Sweet 16 Party

All Colors Discount Sweetheart Beading and Ruffles Sweet Sixteen Quinceanera Dresses

Colorful Sweetheart Quincenaera Dress For Graduation With Beaded Drcorate Ruffle Layers

Hot Pink Ball Gown Sweetheart Floor-length Organza Beading and Ruching Quinceanera Dresses

Aqua Blue Sweetheart Appliques and Beaded Decorate For 2013 Quinceanera Dress

Baby Pink Ruched Bodice Hand Made Flowers Decorate Waist For Quinceanera Dress

Appliques and Pick-ups Wine Red Brush Train Exquisite Style For 2013 Quinceanera Dress

New Style Sequins Spaghetti Straps 2015 Dama Dresses in Blue

Beautiful Ball Gown Strapless 2014 Quinceanera Dresses with Appliques

New Arrival Baby Blue Princesita With Quinceanera Dresses with Appliques and Ruffles

Fairy Two-Tier with Lace Angle Cut Edg Wedding Veils

Two-Tier Tulle Bridal Veils with Ribbon Edge